Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Validating the Accessibility of an OLAP Cube

Cube validation procedures in the `CWM2_OLAP_VALIDATE` package validate the logical structure of an OLAP cube and check that it is correctly mapped to columns in dimension tables and fact tables. However, a cube may be entirely valid according to this criteria and still be inaccessible to your application.

For this reason, you may need to use the `CWM2_OLAP_VERIFY_ACCESS` package to check that the following additional criteria have also been met:

- The metadata tables used by the OLAP API Metadata Reader must be refreshed with the latest changes in the cube's metadata. If these `MRV$` tables have not been updated, you must run the procedures in the `CWM2_OLAP_METADATA_REFRESH` package to enable access by the OLAP API.

- The identity of the application must have access to the source data that underlies the cube. The validation procedures in `CWM2_OLAP_VALIDATE` run under the `SYS` identity. These procedures may indicate that the cube is entirely valid, and yet the application may not be able to access it. If this is the case, you must grant the appropriate rights to the calling user.

# Summary of CWM2_OLAP_VERIFY_ACCESS Subprograms

Table 23-1 CWM2_OLAP_VERIFY_ACCESS

Subprogram | Description
--- | ---
VERIFY_CUBE_ACCESS Procedure | Validates the cube and verifies its accessibility to an OLAP application.

## VERIFY_CUBE_ACCESS Procedure

This procedure first validates a cube by calling the `VALIDATE_CUBE` procedure in the `CWM2_OLAP_VALIDATE` package. Additionally it checks that an OLAP API application running under the identity of the calling user has access to the cube.

Cube accessibility requirements are described in "Validating the Accessibility of an OLAP Cube".

Syntax

    VERIFY_CUBE_ACCESS (
              cube_owner            IN   VARCHAR2,
              cube_name             IN   VARCHAR2,
              type_of_validation    IN   VARCHAR2 DEFAULT 'DEFAULT',
              verbose_report        IN   VARCHAR2 DEFAULT 'YES');

Parameters

Table 23-2 VERIFY_CUBE_ACCESS Procedure Parameters

Parameter | Description
--- | ---
`cube_owner` | Owner of the cube.
`cube_name` | Name of the cube.
`type_of_validation` | `'DEFAULT'` or `'OLAP API'`. See "Validation Type".
`verbose_report` | `'YES'` or `'NO'`. Whether `to` report all validation checks or only major events and errors. By default, all validation checks are reported.